Date Field Format (CX)

About Dashboard Date Field Formats

You can customize the formats of date fields in your dashboard. This can be used to set the day, month, and year order in a date. You can also specify whether the date includes time data (seconds, minutes, etc.) and how you want the time to display.

Dates in the following formats are automatically parsed and do not need their format specified:

• YYYY-MM-dd
• YYYYMMdd
• YYYYMMdd:HHmmss
• YYYY-MM-dd HH:mm:ss
• YYYY-MM-dd‘T’HH:mm:ss.SSS‘Z’

Qtip: You cannot customize date formats for default date fields like Recorded Date, End Date, and Start Date. These default fields are formatted automatically.

Changing Date Formats in the Data Mapper

Qtip: The data mapper is the default, simplest way you define dashboard data. See Data Mapper (CX) for more details.

Default date fields like recorded and end date will follow the time zone of the dashboard. When creating a new date field, the default time zone selected is often GMT, the CX Dashboard default. However, it is best practice to verify the correct time zone for the new field you are adding.

Add a new Date field, or navigate to an existing Date field.

---

×

close

Click on the recode symbol.

Select a Format.

---

×

close

Qtip: The list of date formats is not all inclusive. If you are using a date format that is not in the list, you’ll need to create a custom date format by selecting Custom.

If you selected Custom, then you’ll write out your own format. See a guide to custom date syntax.

---

×

close

Select a Timezone apply to your data.

Click Add to add additional formats and time zones.

Click Apply.

Click Save to save your changes.

Changing Date Formats in Data Models

You can only customize dates at the source in a data model. These formats are then carried through the model’s joins, unions, and output dataset.

Qtip: The time zone of your custom date fields will always match the time zone set for the dashboard.

Select the source that contains the date field.

---

×

close

Select Field editor.

---

×

close

Click the Actions button next to a date field.

Qtip: You may need to scroll to the right to see this menu.

Select Format date.

If you select Custom, you can enter your own date and time format. See Date Format Syntax for a guide.

---

×

close

Otherwise, select a preset format for your dates.

---

×

close

Select the time zone the dates are in.

To add more date formats, click Add format.

To save your changes, click Apply.

Date Format Syntax

To specify a custom format, please use the following symbolic syntax:

Qtip: 2-digit years (e.g. 94 or 24) are interpreted within the date range of 1944-2043. For example, “44” would be processed as “1944”, and “43” would be processed as “2043”. For specificity, use 4-digit years.

For example, if you have date and time data in this format: 2024-08-30T12:30:22, it should be presented in the date format field as YYYY-MM-dd‘T’HH:mm:ss.